/*
CREATE TABLE `book` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uuid` varchar(32) NOT NULL COMMENT '订单uuid',
  `order_uuid` varchar(32) NOT NULL COMMENT '请求者生成订单uuid',
  `name` varchar(45) NOT NULL COMMENT '商品名称',
  `number` int(10) unsigned zerofill NOT NULL COMMENT '商品数量',
  `price` decimal(12,2) NOT NULL COMMENT '商品单价',
  `state` int(11) NOT NULL COMMENT '状态',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uuid_UNIQUE` (`uuid`),
  UNIQUE KEY `order_uuid_UNIQUE` (`order_uuid`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8 COMMENT='订单'
*/
----- delete the table of book'datas.
begin;
truncate  book;
commit;
----- init test data
begin;
insert into book(uuid,order_uuid,name,price,number,state) values(replace(uuid(),'-',''),	replace(uuid(),'-',''),	'初始化数据1',  1,	 1.1,	100);
insert into book(uuid,order_uuid,name,price,number,state) values(replace(uuid(),'-',''),	replace(uuid(),'-',''),	'初始化数据2',  2,	 2.1,	100);
insert into book(uuid,order_uuid,name,price,number,state) values(replace(uuid(),'-',''),	replace(uuid(),'-',''),	'初始化数据3',  3,	 3.1,	100);
insert into book(uuid,order_uuid,name,price,number,state) values(replace(uuid(),'-',''),	replace(uuid(),'-',''),	'初始化数据4',  4,	 4.1,	100);
insert into book(uuid,order_uuid,name,price,number,state) values(replace(uuid(),'-',''),	replace(uuid(),'-',''),	'初始化数据5',  5,	 5.1,	100);
insert into book(uuid,order_uuid,name,price,number,state) values(replace(uuid(),'-',''),	replace(uuid(),'-',''),	'初始化数据6',  6,	 6.1,	100);
insert into book(uuid,order_uuid,name,price,number,state) values(replace(uuid(),'-',''),	replace(uuid(),'-',''),	'初始化数据7',  7,	 7.1,	100);
insert into book(uuid,order_uuid,name,price,number,state) values(replace(uuid(),'-',''),	replace(uuid(),'-',''),	'初始化数据8',  8,	 8.1,	100);
insert into book(uuid,order_uuid,name,price,number,state) values(replace(uuid(),'-',''),	replace(uuid(),'-',''),	'初始化数据9',  9,	 9.1,	100);
insert into book(uuid,order_uuid,name,price,number,state) values(replace(uuid(),'-',''),	replace(uuid(),'-',''),	'初始化数据10',10,	10.1,	100);
insert into book(uuid,order_uuid,name,price,number,state) values(replace(uuid(),'-',''),	replace(uuid(),'-',''),	'初始化数据11',11,	11.1,	100);
insert into book(uuid,order_uuid,name,price,number,state) values(replace(uuid(),'-',''),	replace(uuid(),'-',''),	'初始化数据12',12,	12.1,	100);
insert into book(uuid,order_uuid,name,price,number,state) values(replace(uuid(),'-',''),	replace(uuid(),'-',''),	'初始化数据13',13,	13.1,	100);
insert into book(uuid,order_uuid,name,price,number,state) values(replace(uuid(),'-',''),	replace(uuid(),'-',''),	'初始化数据14',14,	14.1,	100);
insert into book(uuid,order_uuid,name,price,number,state) values(replace(uuid(),'-',''),	replace(uuid(),'-',''),	'初始化数据15',15,	15.1,	100);
insert into book(uuid,order_uuid,name,price,number,state) values(replace(uuid(),'-',''),	replace(uuid(),'-',''),	'初始化数据16',16,	16.1,	100);
insert into book(uuid,order_uuid,name,price,number,state) values(replace(uuid(),'-',''),	replace(uuid(),'-',''),	'初始化数据17',17,	17.1,	100);
insert into book(uuid,order_uuid,name,price,number,state) values(replace(uuid(),'-',''),	replace(uuid(),'-',''),	'初始化数据18',18,	18.1,	100);
insert into book(uuid,order_uuid,name,price,number,state) values(replace(uuid(),'-',''),	replace(uuid(),'-',''),	'初始化数据19',19,	19.1,	100);
insert into book(uuid,order_uuid,name,price,number,state) values(replace(uuid(),'-',''),	replace(uuid(),'-',''),	'初始化数据20',20,	20.1,	100);
commit;
